Page 133 - 2629_Devagiri_C-8

TEST SHEET

Based on Chapters 5 to 8
2

A. Tick ( ) the correct option.
1. Mark the constraint that is used to specify a default value for a column.

(i) Default Constraint (ii) NOT NULL Constraint

(iii) Check Constraint (iv) NULL Constraint

2. Select the method used to organise the creation, editing and display of data in a table.

(i) Table (ii) Form

(iii) Query (iv) Report

3. Which type of data includes images, videos and audio files?
(i) Unstructured Data (ii) Structured Data

(iii) Semi-structured Data (iv) Logical Data
4. Identify a source of data that collects real-time information in industries and healthcare.

(i) Social media (ii) Sensors

(iii) Surveys (iv) Apps

5. Select the control block that repeats a set of instructions endlessly until stopped.

(i) repeat (ii) while
(iii) wait until (iv) forever

6. Spot the sensor that reports the robot’s (X, Y) coordinate position and heading angle.
(i) Distance sensor (ii) Eye sensor

(iii) Location sensor (iv) Gyro sensor

7. Identify the function that is used to generate a sequence of numbers.

(i) sequence() (ii) generate()

(iii) range() (iv) list()

8. Which of the following loops is used when the number of repetitions is not known in advance?

(i) for loop (ii) while loop

(iii) break loop (iv) continue loop

B. Write ‘T’ for true and ‘F’ for false.
1. There can be more than one primary key in a table.

131
Test Sheet - 2